🕷️️ Job Radar • SCRAPING

upwork.com 🟡 2026-05-22

🔹 US 503A/503B Pharmacy Lead Generation
👤 Client: 🇬🇧 United Kingdom Member since 2023-03-19
💰 Price: ****
🚩 Problem: Lack of a centralized database of US compounding pharmacies for email outreach.
📦 Existing: Target URLs: a4pc.org, pccarx.com, fda.gov, cms.gov (NPI files).

Specifications:

[Target] 503A and 503B Pharmacies (USA)
[Method] Web scraping and NPI dataset parsing
[Stack] Google Sheets
[Format] Company name, Address, Owner name, Phone, Website, Email, Category
[Format] Multi-tab structure (one tab per source)

Workflow:

1. Extraction of 503B data from FDA, A4PC, and PCCARx portals.
2. Parsing of CMS NPI files for pharmacy identification and contact details.
3. Email discovery and validation for identified entities.
4. Data consolidation into source-specific Google Sheet tabs.